-- ****** Object: Table ASM_GEP.GEP_UTENTI Script Date: 17/12/2012 23:24:29 ******
CREATE TABLE "GEP_UTENTI" (
  "USERNAME" VARCHAR2(20 BYTE) NOT NULL,
  "PASSWORD" VARCHAR2(20 BYTE) NOT NULL,
  "NOME" VARCHAR2(20 BYTE) NOT NULL,
  "COGNOME" VARCHAR2(20 BYTE) NOT NULL,
  "ISADMIN" NUMBER(1,0) DEFAULT 0 NOT NULL,
  "ID" NUMBER NOT NULL,
  "ROLEC" NUMBER(1,0) NOT NULL,
  "ROLEV" NUMBER(1,0) NOT NULL)
  STORAGE ( 
    NEXT 1048576 ) 
/
CREATE UNIQUE INDEX "CONSTRAINT3"
  ON "GEP_UTENTI" ( 
    "ID")
/
ALTER TABLE "GEP_UTENTI" ADD ( 
  CONSTRAINT "CONSTRAINT3" 
    PRIMARY KEY ( "ID") 
    USING INDEX "CONSTRAINT3" 
    ENABLE 
    VALIDATE )
/
